Student Solution

-->

"Education is the most powerful weapon which you can use to change the world”
– Nelson Mandela

1 University

1 Course

1 Subject

Excel Assignment-3

Excel Assignment-3

Q Here is your third and final Excel Assignment. This is a formative assessment where you are working on using Excel to prepare a Statement of Cash Flows. Make sure you follow the General Instructions for Excel Assignments. Here are the specific instructions for Excel Assignment #3. Please upload your Excel assignment below. Make sure you have saved the assignment with an xls or xlsx extension. Rubric Excel Rubric Excel Rubric Criteria Ratings Pts This criterion is linked to a Learning OutcomeExcel Work 10 to >9.0 pts Excellent Use of excel formulas to do all mathematical calculations. Appropriate use of underlines, double underlines. No misspellings. Appropriate rounding. 9 to >7.0 pts Good Mostly uses formulas to do mathematical calculations. Slight misspelling, rounding error and/or formatting issues. 7 to >6.0 pts Average Uses some formulas but not more than half. More than three misspellings. More than one formatting issues. No underlines used. 6 to >0 pts Below Average Uses no formulas, types in numbers. Or types in numbers and add them together. Several misspellings, formatting sloppy. 10 pts This criterion is linked to a Learning OutcomeAccounting Understanding 10 to >9.0 pts Excellent Strong understanding of the underlying issues in solving the accounting problem. Answer is correct. 9 to >7.0 pts Good Decent understanding of the accounting issues being presented. Answer is mostly correct. 7 to >6.0 pts Average Decent understanding of the accounting issues being presented. Answer is at least 70% correct. 6 to >0 pts Below Average Incomplete understanding of the accounting issues. More than half the answer is incorrect. 10 pts Total Points: 20 PreviousNext

View Related Questions

Solution Preview

Cash Flows from Operating Activities: Net Income 1,80,600 Adjustments to Reconcile Net Income to Net Cash Provided by Operating Activities: Depreciation Expense 26,000 Gain on Sale of Investments -12,000 Increase in Accounts Receivable -17,500 Increase in Inventories -27,100 Increase in Accounts Payable 18,200 Decrease in Salaries Payable -4,900 -17,300 Net Cash Provided by Operating Activities 1,63,300 Cash Flows from Investing Activities: Sale of Investments 1,32,000 Purchase of Land -1,60,000 Purchase of Equipment -1,20,000 Net Cash Used by Investing Activities -1,48,000 Cash Flows from Financing Activities: Issuance of Stock 1,05,000 Payment of Dvidends -52,000 Net Cash Provided by Financing Activities 53,000